Question : Document all CALCULATED & ALIASES in an Access database | LOG | ACC
Answered by : shane-eckel
SELECT mQ.Name1 AS FieldName
, mo.Name AS QryName
, mQ.Expression
FROM MSysObjects AS mo
INNER JOIN MSysQueries AS mQ
ON mo.Id = mQ.ObjectId
WHERE ( (mQ.Name1 Is Not Null)
AND (left(mo.Name,1) Not IN ("~","{"))
AND (mQ.Expression Is Not Null)
AND (mQ.Attribute=6) )
ORDER BY mQ.Name1
, mo.Name;
Source : http://www.rogersaccesslibrary.com/forum/document-calculated-fields-in-queries_topic619.html | Last Update : Thu, 13 Oct 22